package com.api.shopapi.mapper;

import com.api.shopapi.entity.RechargeInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface ExportOldestMapper {

    //充值明细导出
    @Select("select * from recharge as r left join (select RechargeGroupCode,Name from recharge_group ) as rg" +
            " on r.RechargeGroupCode=rg.RechargeGroupCode  where r.RechargeGroupCode=#{rechargeGroupCode}  ")
    List<RechargeInfo> getForRechargeInfo(@Param("rechargeGroupCode") String rechargeGroupCode);
}
